SUPPORT / SAMPLES & SAS NOTES
Problem Note 59813: Using inline functions with the ODS destination for Excel might not display the function output correctly
 |  |  |  |
Inline functions that you use with the ODS destination for Excel might not display the function output correctly. If an inline function such as the SUPER function is specified, the character is removed unless a space is inserted between the inline function and the character. Inserting a space enables the character to be displayed in the output. Also, any space that is added prior to the inline function is removed in the output.
Below is an example that demonstrates the problem when the SUPER function is specified within a label that does not contain a space between the inline function and the character or string.
ods escapechar='^';
ods excel file='c:\temp\test.xlsx';
proc print data=sashelp.class label;
label age='^{super(Age)}';
run;
ods excel close;
ods excel file='c:\temp\test.xlsx';
proc print data=sashelp.class label;
label age='^{super(Age)}';
run;
ods excel close;
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | Base SAS | z/OS | 9.4 TS1M3 | 9.4 TS1M5 |
| z/OS 64-bit | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Microsoft® Windows® for x64 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Microsoft Windows 8 Enterprise 32-bit | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Microsoft Windows 8 Enterprise x64 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Microsoft Windows 8 Pro 32-bit | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Microsoft Windows 8 Pro x64 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Microsoft Windows 8.1 Enterprise x64 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Microsoft Windows 8.1 Pro 32-bit | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Microsoft Windows 8.1 Pro x64 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Microsoft Windows 10 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Microsoft Windows Server 2008 | 9.4 TS1M3 | |||
| Microsoft Windows Server 2008 R2 | 9.4 TS1M3 | |||
| Microsoft Windows Server 2008 for x64 | 9.4 TS1M3 | |||
| Microsoft Windows Server 2012 Datacenter | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Microsoft Windows Server 2012 R2 Std | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Microsoft Windows Server 2012 Std | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Windows 7 Enterprise 32 bit | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Windows 7 Enterprise x64 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Windows 7 Home Premium 32 bit | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Windows 7 Home Premium x64 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Windows 7 Professional 32 bit | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Windows 7 Professional x64 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Windows 7 Ultimate 32 bit | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Windows 7 Ultimate x64 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| 64-bit Enabled AIX | 9.4 TS1M3 | 9.4 TS1M5 | ||
| 64-bit Enabled Solaris | 9.4 TS1M3 | 9.4 TS1M5 | ||
| HP-UX IPF | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Linux for x64 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Solaris for x64 | 9.4 TS1M3 | 9.4 TS1M5 | ||